Tabela ResourceItem

Definicja tabeli ResourceItem

Name

ResourceItem

Code

ResourceItem

Comment

 


Lista kolumn tabeli ResourceItem

Name

Code

ResourceID

ResourceID

ResourceItemKindID

ResourceItemKindID

ResourceTypeID

ResourceTypeID

UnitID

UnitID

ResourceRecipeID

ResourceRecipeID

Code

Code

ShortName

ShortName

FullName

FullName

Description

Description

StartDT

StartDT

StopDT

StopDT

Comments

Comments

Active

Active

ContractPrice

ContractPrice

SentToSupply

SentToSupply

PhResourceID

PhResourceID


Kolumna ResourceID tabeli ResourceItem

Definicja kolumny ResourceID tabeli ResourceItem

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ResourceItemKindID tabeli ResourceItem

Definicja kolumny ResourceItemKindID tabeli ResourceItem

Name

ResourceItemKindID

Code

ResourceItemKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ResourceTypeID tabeli ResourceItem

Definicja kolumny ResourceTypeID tabeli ResourceItem

Name

ResourceTypeID

Code

ResourceTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UnitID tabeli ResourceItem

Definicja kolumny UnitID tabeli ResourceItem

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ResourceRecipeID tabeli ResourceItem

Definicja kolumny ResourceRecipeID tabeli ResourceItem

Name

ResourceRecipeID

Code

ResourceRecipeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Code tabeli ResourceItem

Definicja kolumny Code tabeli ResourceItem

Name

Code

Code

Code

Data Type

VARCHAR2(24)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna ShortName tabeli ResourceItem

Definicja kolumny ShortName tabeli ResourceItem

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli ResourceItem

Definicja kolumny FullName tabeli ResourceItem

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Description tabeli ResourceItem

Definicja kolumny Description tabeli ResourceItem

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna StartDT tabeli ResourceItem

Definicja kolumny StartDT tabeli ResourceItem

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli ResourceItem

Definicja kolumny StopDT tabeli ResourceItem

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Comments tabeli ResourceItem

Definicja kolumny Comments tabeli ResourceItem

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Active tabeli ResourceItem

Definicja kolumny Active tabeli ResourceItem

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna ContractPrice tabeli ResourceItem

Definicja kolumny ContractPrice tabeli ResourceItem

Name

ContractPrice

Code

ContractPrice

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna SentToSupply tabeli ResourceItem

Definicja kolumny SentToSupply tabeli ResourceItem

Name

SentToSupply

Code

SentToSupply

Data Type

NUMBER(1)

Mandatory

No

Comment

Kolumna okresla czy informacje o diecie maja byc wyslane do dostawcy


Kolumna PhResourceID tabeli ResourceItem

Definicja kolumny PhResourceID tabeli ResourceItem

Name

PhResourceID

Code

PhResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

pole przechowywac bedzie identyfikator aliasu srodków z apteki (analog
PhStItemID)


Lista kluczy tabeli ResourceItem

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ResourceItem

Definicja klucza Identifier_1 tabeli ResourceItem

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment